home *** CD-ROM | disk | FTP | other *** search
/ ftp2.jacobs.com / 2015.02.ftp2.jacobs.com.tar / ftp2.jacobs.com / pub / iPass / Open Mobile-V2.3.0-11624-V9.000.msi / Data1.cab / _4DF44CCB96E36C00DB10216545EB7CF1 < prev    next >
Text File  |  2012-10-24  |  2KB  |  61 lines
  1. ∩╗┐DROP TRIGGER UPDATE_NEP_ID;
  2. DROP TRIGGER UPDATE_ALLOW_CONNECT;
  3. DROP TRIGGER UPDATE_PRIORITY_SCORE;
  4. DROP TRIGGER UPDATE_DISPLAY_NETWORK;
  5. DROP TRIGGER UPDATE_SIGNAL_STRENGTH_BARS;
  6.  
  7. DROP VIEW CHARACTERIZED_WIFI_NW_VIEW;
  8.  
  9. DROP TABLE ANNOTATION_DEFINITION;
  10. DROP TABLE ANNOTATION_LOCALIZATION;
  11. DROP TABLE CHARACTERIZED_NETWORKS;
  12. DROP TABLE NETWORK_ANNOTATIONS;
  13. DROP TABLE SNIFFED_NETWORKS;
  14.  
  15. CREATE TABLE CONNECTION_USAGE_ALERTS_HISTORY (
  16. ATTEMPT_ID            INTEGER NOT NULL,
  17. MEDIATYPE            INTEGER,
  18. ID                      VARCHAR(32),
  19. MACADDRESSS         VARCHAR(32),
  20. SESSION_START_TIME  TIMESTAMP,
  21. SESSION_STOP_TIME   TIMESTAMP,
  22. BYTES_SENT          INTEGER,
  23. BYTES_RECVD         INTEGER,
  24. TOTAL_USAGE         INTEGER,
  25. IS_ROAMING             VARCHAR(3),
  26. PRIMARY KEY (ATTEMPT_ID));
  27.  
  28. INSERT INTO CONNECTION_USAGE_ALERTS_HISTORY (ATTEMPT_ID, 
  29. MEDIATYPE, 
  30. ID, 
  31. MACADDRESSS, 
  32. SESSION_START_TIME, 
  33. SESSION_STOP_TIME, 
  34. BYTES_SENT, 
  35. BYTES_RECVD, 
  36. TOTAL_USAGE, 
  37. IS_ROAMING) 
  38. SELECT ATTEMPT_ID, 
  39. 4,
  40. SUBSCRIBER_NUMBER,
  41. null, 
  42. SESSION_START_TIME, 
  43. SESSION_STOP_TIME, 
  44. BYTES_SENT,        
  45. BYTES_RECVD,         
  46. TOTAL_USAGE,       
  47. IS_ROAMING
  48. FROM MOBILEDATA_CONNECTION_USAGE_HISTORY;
  49.  
  50. DROP TABLE MOBILEDATA_CONNECTION_USAGE_HISTORY;
  51.  
  52. CREATE TABLE CONNECTION_USAGE_ALERTS_WARNING (
  53. ID                        VARCHAR(32),
  54. BILLING_CYCLE_START_TIME        TIMESTAMP,
  55. BILLING_CYCLE_STOP_TIME        TIMESTAMP,
  56. MACADDRESSS             VARCHAR(32),
  57. IS_ROAMING                 VARCHAR(3),
  58. LAST_WARNING            INTEGER);
  59.  
  60. DELETE FROM OM_DATABASE_VERSION;
  61. INSERT INTO OM_DATABASE_VERSION VALUES ('2.0');